package com.ny.dao;

import com.ny.demo523.sqlConnection;
import com.ny.wlw.Users;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {

    Connection connection = sqlConnection.getCon();

    public UserDao() throws SQLException, ClassNotFoundException {
    }

    public int addUser(String username,String password) throws SQLException, ClassNotFoundException {

        String sql = "insert into users(username,password) values(?,?)";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1,username);
        preparedStatement.setString(2,password);
        return preparedStatement.executeUpdate();

    }
    public  Users login(String username,String password) throws SQLException, ClassNotFoundException {
        Users users = null;
        int i = 1;
        String sql = "select * from users where username = ? and password = ?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setString(1,username);
        preparedStatement.setString(2,password);
        ResultSet resultSet = preparedStatement.executeQuery();
        if(resultSet.next()){
            users = new Users();
            users.setId(resultSet.getInt("id"));
            users.setUsername(resultSet.getString("username"));
            users.setPassword(resultSet.getString("password"));
        }
        return users;
    }
    public int deleteUsers(int id) throws SQLException, ClassNotFoundException {
        String sql = "delete from users where id = ?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setInt(1,id);
        return preparedStatement.executeUpdate();
    }
}
